var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');
const { env } = process;
env.BINDINGS_DEBUG = 1;
console.log(env);

var mock = require('./routes/mock-api');
var {execSql} = require('./routes/db/mysql')
var moment = require('moment');
var app = express();
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'ejs');

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/mockapi', mock);
app.use('/api-add', (req,res)=>{
  res.render('api-add',{'title':'express2'})
});
app.use('/mockapi',function(req,res){
  res.render('mockapi');
})

app.use('/mock',async (req, res, next)=>{
  //记录接口调用
  var url = req.originalUrl
  var time = moment(Date.now()).format('YYYY-MM-DD HH:mm:ss')
  var sql = 'insert into api_log (url,ip,time) VALUES (\''+url+'\',';
  sql = sql+'\''+req.ip+'\',';
  sql = sql+'\''+time+'\');';;
  var ret = await execSql(sql)
  next()
})
app.use('/mock',mock)
app.use('/msvr-lz',mock)


// catch 404 and forward to error handler
app.use(function(req, res, next) {
  next(createError(404));
});

// error handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});


module.exports = app;
